{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["4.1","4.3","4.4","4.6","4.7","4.8","4.9","4.10","4.13","4.14","4.15"],"not_rendered":{"charts":1,"images":3,"macros":1,"external_links":0,"defined_names":20,"comments":6,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"4.1","index":0,"n_rows":48,"n_cols":3,"rows_kept":48,"cut":false,"hidden":false,"merged":[[6,2,6,3],[1,2,1,3],[5,2,5,3],[2,2,2,3],[3,2,3,3],[4,2,4,3],[7,2,7,3],[8,2,8,3],[9,2,9,3],[10,2,10,3],[11,2,11,3],[17,2,17,3],[18,2,18,3],[19,2,19,3],[20,2,20,3],[12,2,12,3],[13,2,13,3],[14,2,14,3],[15,2,15,3],[16,2,16,3],[36,2,36,3],[29,2,29,3],[30,2,30,3],[21,2,21,3],[32,2,32,3],[22,2,22,3],[23,2,23,3],[24,2,24,3],[25,2,25,3],[26,2,26,3],[27,2,27,3],[47,2,47,3],[28,2,28,3],[31,2,31,3],[43,2,43,3],[44,2,44,3],[45,2,45,3],[46,2,46,3],[37,2,37,3],[38,2,38,3],[39,2,39,3],[40,2,40,3],[41,2,41,3],[42,2,42,3],[33,2,33,3],[34,2,34,3],[35,2,35,3]]}
[]
[null,null,"Moving and scrolling"]
[null,"Home","Move to the beginning of the row"]
[null,"Ctrl + Home","Move to the beginning of the worksheet (A1)"]
[null,"Ctrl + End","Move to the bottom-right corner of the used area of the worksheet"]
[null,"Ctrl + arrow key","Move to the edge of the current data region"]
[null,"PgDn","Move down one screen"]
[null,"PgUp","Move up one screen"]
[null,"Alt + PgDn","Move one screen to the right"]
[null,"Alt + PgUp","Move one screen to the left"]
[]
[null,null,"Entering data on a worksheet"]
[null,"Shift + Enter","Complete a cell entry and move up one cell"]
[null,"Tab","Complete a cell entry and move to the right cell"]
[null,"Shift + Tab","Complete a cell entry and move to the left cell"]
[null,"Ctrl + Delete","Delete text to the end of the line"]
[null,"Shift + F2","Edit a cell comment"]
[null,"Ctrl + D","Fill down (a selected column of cells with the content of the first cell)"]
[null,"Ctrl + R","Fill to the right (a selected row of cells with the content of the first cell)"]
[]
[null,null,"Working in cells or the formula bar"]
[null,"Ctrl+ ~ ","Display all formulas"]
[null,"F2","Edit the active cell"]
[null,"F3","Open the Paste Name window"]
[null,"Shift + F3","Open the Insert Function (or Function Arguments) window"]
[null,"F9","Calculate all sheets in all open workbooks"]
[null,"Ctrl + Alt + F9","Calculate all worksheets in the active workbook"]
[null,"Shift + F9","Calculate the active worksheet"]
[null,"Ctrl + Shift + Enter","Enter a formula as an array formula"]
[null,"Ctrl + ;(semicolon)","Enter the current date"]
[null,"Ctrl + Shift + :(colon)","Enter the current time"]
[]
[null,null,"Inserting, deleting, and copying selection"]
[null,"Delete","Clear the contents of the selection"]
[null,"Ctrl + - (hyphen)","Delete (dialog box)"]
[null,"Ctrl + Z","Undo the last action"]
[null,"Ctrl + Shift + Plus sign","Insert (dialog box)"]
[]
[null,null,"Selecting cells, columns, or rows"]
[null,"Shift + arrow key","Extend the selection by one cell"]
[null,"Ctrl + Shift + arrow key","Extend the selection to the last nonblank cell in the same column or row"]
[null,"Ctrl + space bar","Select the entire column"]
[null,"Ctrl + A","Select the entire worksheet"]
[]
[null,null,"Working with macros"]
[null,"Alt + F8","Display the Macro dialog box"]
[null,"Alt + F11","Display the Visual Basic Editor (VBE)"]
[null,null,"Note:  In most cases, these shortcuts are not case sensitive."]

{"sheet":"4.3","index":1,"n_rows":43,"n_cols":7,"rows_kept":43,"cut":false,"hidden":false,"merged":[]}
["Control panel"]
[null,null,null,null,null,"Cost quotes"]
["Choose building costs",null,null,null,null,78.5]
[{"$f":"INDEX(F3:F5,F6)","v":80},null,null,null,null,80]
[null,null,null,null,null,83.75]
[null,null,null,null,null,2]
[]
["Sale multiple"]
[12]
[]
[]
["NPV"]
[{"$f":"B43","v":11472032.029742127}]
[]
[]
[]
["Office Building"]
[]
["Parameters","Rate of increase",2002,2003,2004,2005,2006]
["Building cost per sq ft",null,{"$f":"A4","v":80}]
["Size of building",null,180000]
["Rent per sq ft",0.05,15,{"$f":"C22*(1+$B$22)","v":15.75},{"$f":"D22*(1+$B$22)","v":16.537500000000001},{"$f":"E22*(1+$B$22)","v":17.364375000000003},{"$f":"F22*(1+$B$22)","v":18.232593750000003}]
["Operating expense per sq ft",0.06,1.2,{"$f":"C23*(1+$B$23)","v":1.272},{"$f":"D23*(1+$B$23)","v":1.3483200000000002},{"$f":"E23*(1+$B$23)","v":1.4292192000000004},{"$f":"F23*(1+$B$23)","v":1.5149723520000005}]
["Vacancy rate",-0.04,0.3,{"$f":"C24+$B$24","v":0.26},{"$f":"D24+$B$24","v":0.22},{"$f":"E24+$B$24","v":0.18},{"$f":"F24+$B$24","v":0.13999999999999999}]
["Percent financed",null,0.85]
["Mortgage rate",null,0.12]
["Sale multiple",null,{"$f":"A9","v":12}]
["Cost of capital",null,0.1]
[]
[null,null,2002,2003,2004,2005,2006]
["Cash Flow"]
[null,"Gross income",{"$f":"$C$21*C22*(1-C24)","v":1889999.9999999998},{"$f":"$C$21*D22*(1-D24)","v":2097900},{"$f":"$C$21*E22*(1-E24)","v":2321865.0000000005},{"$f":"$C$21*F22*(1-F24)","v":2562981.7500000005},{"$f":"$C$21*G22*(1-G24)","v":2822405.5125000002}]
[null,"Operating expense",{"$f":"$C$21*C23","v":216000},{"$f":"$C$21*D23","v":228960},{"$f":"$C$21*E23","v":242697.60000000003},{"$f":"$C$21*F23","v":257259.45600000006},{"$f":"$C$21*G23","v":272695.02336000011}]
[null,"Net operating income",{"$f":"C32-C33","v":1673999.9999999998},{"$f":"D32-D33","v":1868940},{"$f":"E32-E33","v":2079167.4000000004},{"$f":"F32-F33","v":2305722.2940000002},{"$f":"G32-G33","v":2549710.4891400002}]
[null,"Interest cost",{"$f":"-12*ISPMT($C$26/12,1,360,$C$25*$C$20*$C$21)","v":1464720},{"$f":"-12*ISPMT($C$26/12,1,360,$C$25*$C$20*$C$21)","v":1464720},{"$f":"-12*ISPMT($C$26/12,1,360,$C$25*$C$20*$C$21)","v":1464720},{"$f":"-12*ISPMT($C$26/12,1,360,$C$25*$C$20*$C$21)","v":1464720},{"$f":"-12*ISPMT($C$26/12,1,360,$C$25*$C$20*$C$21)","v":1464720}]
[null,"Before-tax cash flow",{"$f":"C34-C35","v":209279.99999999977},{"$f":"D34-D35","v":404220},{"$f":"E34-E35","v":614447.40000000037},{"$f":"F34-F35","v":841002.29400000023},{"$f":"G34-G35","v":1084990.4891400002}]
[]
[null,"Down payment (at time 0)",{"$f":"(1-C25)*C20*C21","v":2160000.0000000005}]
[null,"Sale price",null,null,null,null,{"$f":"C27*G34","v":30596525.869680002}]
[null,"Mortgage cost",null,null,null,null,{"$f":"C25*C20*C21","v":12240000}]
[null,"End of year cash flows",{"$f":"C36","v":209279.99999999977},{"$f":"D36","v":404220},{"$f":"E36","v":614447.40000000037},{"$f":"F36","v":841002.29400000023},{"$f":"G36+G39-G40","v":19441516.358820003}]
[]
["NPV",{"$f":"NPV(C28,C41:G41)-C38","v":11472032.029742127}]

{"sheet":"4.4","index":2,"n_rows":27,"n_cols":7,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
["Office Building"]
[]
["Parameters","Rate of increase",2002,2003,2004,2005,2006]
["Building cost per sq ft",null,80]
["Size of building",null,180000]
["Rent per sq ft",0.05,15,{"$f":"C6*(1+$B$6)","v":15.75},{"$f":"D6*(1+$B$6)","v":16.537500000000001},{"$f":"E6*(1+$B$6)","v":17.364375000000003},{"$f":"F6*(1+$B$6)","v":18.232593750000003}]
["Operating expense per sq ft",0.06,1.2,{"$f":"C7*(1+$B$7)","v":1.272},{"$f":"D7*(1+$B$7)","v":1.3483200000000002},{"$f":"E7*(1+$B$7)","v":1.4292192000000004},{"$f":"F7*(1+$B$7)","v":1.5149723520000005}]
["Vacancy rate",-0.04,0.3,{"$f":"C8+$B$8","v":0.26},{"$f":"D8+$B$8","v":0.22},{"$f":"E8+$B$8","v":0.18},{"$f":"F8+$B$8","v":0.13999999999999999}]
["Percent financed",null,0.85]
["Mortgage rate",null,0.12]
["Sale multiple",null,12]
["Cost of capital",null,0.1]
[]
[null,null,2002,2003,2004,2005,2006]
["Cash Flow"]
[null,"Gross income",{"$f":"$C$5*C6*(1-C8)","v":1889999.9999999998},{"$f":"$C$5*D6*(1-D8)","v":2097900},{"$f":"$C$5*E6*(1-E8)","v":2321865.0000000005},{"$f":"$C$5*F6*(1-F8)","v":2562981.7500000005},{"$f":"$C$5*G6*(1-G8)","v":2822405.5125000002}]
[null,"Operating expense",{"$f":"$C$5*C7","v":216000},{"$f":"$C$5*D7","v":228960},{"$f":"$C$5*E7","v":242697.60000000003},{"$f":"$C$5*F7","v":257259.45600000006},{"$f":"$C$5*G7","v":272695.02336000011}]
[null,"Net operating income",{"$f":"C16-C17","v":1673999.9999999998},{"$f":"D16-D17","v":1868940},{"$f":"E16-E17","v":2079167.4000000004},{"$f":"F16-F17","v":2305722.2940000002},{"$f":"G16-G17","v":2549710.4891400002}]
[null,"Interest cost",{"$f":"-12*ISPMT($C$10/12,1,360,$C$9*$C$4*$C$5)","v":1464720},{"$f":"-12*ISPMT($C$10/12,1,360,$C$9*$C$4*$C$5)","v":1464720},{"$f":"-12*ISPMT($C$10/12,1,360,$C$9*$C$4*$C$5)","v":1464720},{"$f":"-12*ISPMT($C$10/12,1,360,$C$9*$C$4*$C$5)","v":1464720},{"$f":"-12*ISPMT($C$10/12,1,360,$C$9*$C$4*$C$5)","v":1464720}]
[null,"Before-tax cash flow",{"$f":"C18-C19","v":209279.99999999977},{"$f":"D18-D19","v":404220},{"$f":"E18-E19","v":614447.40000000037},{"$f":"F18-F19","v":841002.29400000023},{"$f":"G18-G19","v":1084990.4891400002}]
[]
[null,"Down payment (at time 0)",{"$f":"(1-C9)*C4*C5","v":2160000.0000000005}]
[null,"Sale price",null,null,null,null,{"$f":"C11*G18","v":30596525.869680002}]
[null,"Mortgage cost",null,null,null,null,{"$f":"C9*C4*C5","v":12240000}]
[null,"End of year cash flows",{"$f":"C20","v":209279.99999999977},{"$f":"D20","v":404220},{"$f":"E20","v":614447.40000000037},{"$f":"F20","v":841002.29400000023},{"$f":"G20+G23-G24","v":19441516.358820003}]
[]
["NPV",{"$f":"NPV(C12,C25:G25)-C22","v":11472032.029742127}]

{"sheet":"4.6","index":3,"n_rows":43,"n_cols":7,"rows_kept":43,"cut":false,"hidden":false,"merged":[]}
["Office Building"]
[]
["Parameters","Rate of increase",2002,2003,2004,2005,2006]
["Building cost per sq ft",null,80]
["Size of building",null,180000]
["Rent per sq ft",0.05,15,{"$f":"C6*(1+$B$6)","v":15.75},{"$f":"D6*(1+$B$6)","v":16.537500000000001},{"$f":"E6*(1+$B$6)","v":17.364375000000003},{"$f":"F6*(1+$B$6)","v":18.232593750000003}]
["Operating expense per sq ft",0.06,1.2,{"$f":"C7*(1+$B$7)","v":1.272},{"$f":"D7*(1+$B$7)","v":1.3483200000000002},{"$f":"E7*(1+$B$7)","v":1.4292192000000004},{"$f":"F7*(1+$B$7)","v":1.5149723520000005}]
["Vacancy rate",-0.04,0.3,{"$f":"C8+$B$8","v":0.26},{"$f":"D8+$B$8","v":0.22},{"$f":"E8+$B$8","v":0.18},{"$f":"F8+$B$8","v":0.13999999999999999}]
["Percent financed",null,0.85]
["Mortgage rate",null,0.12]
["Sale multiple",null,12]
["Cost of capital",null,0.1]
[]
[null,null,2002,2003,2004,2005,2006]
["Cash Flow"]
[null,"Gross income",{"$f":"Size*Rent*(1-Vacancy)","v":1889999.9999999998},{"$f":"Size*D6*(1-D8)","v":2097900},{"$f":"Size*E6*(1-E8)","v":2321865.0000000005},{"$f":"Size*F6*(1-F8)","v":2562981.7500000005},{"$f":"Size*G6*(1-G8)","v":2822405.5125000002}]
[null,"Operating expense",{"$f":"Size*Operating_expense","v":216000},{"$f":"$C$5*D7","v":228960},{"$f":"$C$5*E7","v":242697.60000000003},{"$f":"$C$5*F7","v":257259.45600000006},{"$f":"$C$5*G7","v":272695.02336000011}]
[null,"Net operating income",{"$f":"C16-C17","v":1673999.9999999998},{"$f":"D16-D17","v":1868940},{"$f":"E16-E17","v":2079167.4000000004},{"$f":"F16-F17","v":2305722.2940000002},{"$f":"G16-G17","v":2549710.4891400002}]
[null,"Interest cost",{"$f":"-12*ISPMT(Mortgage_rate/12,1,360,Percent_financed*Building_cost*Size)","v":1464720},{"$f":"-12*ISPMT(Mortgage_rate/12,1,360,Percent_financed*Building_cost*Size)","v":1464720},{"$f":"-12*ISPMT(Mortgage_rate/12,1,360,Percent_financed*Building_cost*Size)","v":1464720},{"$f":"-12*ISPMT(Mortgage_rate/12,1,360,Percent_financed*Building_cost*Size)","v":1464720},{"$f":"-12*ISPMT(Mortgage_rate/12,1,360,Percent_financed*Building_cost*Size)","v":1464720}]
[null,"Before-tax cash flow",{"$f":"C18-C19","v":209279.99999999977},{"$f":"D18-D19","v":404220},{"$f":"E18-E19","v":614447.40000000037},{"$f":"F18-F19","v":841002.29400000023},{"$f":"G18-G19","v":1084990.4891400002}]
[]
[null,"Down payment (at time 0)",{"$f":"(1-Percent_financed)*Building_cost*Size","v":2160000.0000000005}]
[null,"Sale price",null,null,null,null,{"$f":"C11*G18","v":30596525.869680002}]
[null,"Mortgage cost",null,null,null,null,{"$f":"C9*C4*C5","v":12240000}]
[null,"End of year cash flows",{"$f":"C20","v":209279.99999999977},{"$f":"D20","v":404220},{"$f":"E20","v":614447.40000000037},{"$f":"F20","v":841002.29400000023},{"$f":"G20+G23-G24","v":19441516.358820003}]
[]
["NPV",{"$f":"NPV(Cost_of_Capital,End_of_year_cash_flows)-Down_payment__at_time_0","v":11472032.029742127}]
[]
[]
["Range Names","Building_cost","='4.6'!$C$4"]
[null,"Cost_of_Capital","='4.6'!$C$12"]
[null,"Down_payment__at_time_0","='4.6'!$C$22"]
[null,"End_of_year_cash_flows","='4.6'!$C$25:$G$25"]
[null,"Mortgage_rate","='4.6'!$C$10"]
[null,"Operating_expense","='4.6'!$C$7"]
[null,"Operating_expense_growth","='4.6'!$B$7"]
[null,"Percent_financed","='4.6'!$C$9"]
[null,"Rent","='4.6'!$C$6"]
[null,"Rent_growth","='4.6'!$B$6"]
[null,"Sale_multiple","='4.6'!$C$11"]
[null,"Size","='4.6'!$C$5"]
[null,"Vacancy","='4.6'!$C$8"]
[null,"Vacancy_growth","='4.6'!$B$8"]

{"sheet":"4.7","index":4,"n_rows":18,"n_cols":13,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
["Mixed addressing"]
[]
[null,"start temp",50]
[null,"fridge temp",36]
[]
[null,"k values",0.1]
[null,null,0.2]
[null,null,0.3]
[null,null,0.4]
[null,null,0.5]
[]
[null,null,"Time",1,2,3,4,5,6,7,8,9,10]
[null,"Case"]
[null,1,{"$f":"$C$3","v":50},{"$f":"C14-$C6*(C14-$C$4)","v":48.6},47.34,46.206000000000003,45.185400000000001,44.266860000000001,43.440173999999999,42.696156600000002,42.026540940000004,41.423886846000002,40.881498161400003]
[null,2,{"$f":"$C$3","v":50},47.2,44.96,43.167999999999999,41.734400000000001,40.587519999999998,39.670015999999997,38.9360128,38.348810239999999,37.879048191999999,37.503238553599999]
[null,3,50,45.8,42.86,40.802,39.361400000000003,38.352980000000002,37.647086000000002,37.152960200000003,36.807072140000002,36.564950498000002,36.395465348599998]
[null,4,50,44.4,41.04,39.024000000000001,37.814399999999999,37.088639999999998,36.653183999999996,36.3919104,36.235146239999999,36.141087743999996,36.084652646399995]
[null,5,50,43,39.5,37.75,36.875,36.4375,36.21875,36.109375,36.0546875,36.02734375,36.013671875]

{"sheet":"4.8","index":5,"n_rows":8,"n_cols":13,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Inputs"]
[null,"IShare",0.05]
[null,"Change_year",2005]
[null,"Years_growth",3]
[null,"Fshare",0.15]
[]
[null,"Year",2000,2001,2002,2003,2004,2005,2006,2007,2008,2009,2010]
[null,"Share",{"$f":"IF(C7<Change_year,IShare,IF(C7>Change_year+Years_growth,Fshare,(IShare+(C7-Change_year)*(Fshare-IShare)/Years_growth)))","v":0.05},0.05,0.05,0.05,0.05,0.05,8.3333333333333343E-2,0.11666666666666667,0.15,0.15,0.15]

{"sheet":"4.9","index":6,"n_rows":55,"n_cols":9,"rows_kept":55,"cut":false,"hidden":false,"merged":[]}
["Cumulative capacity "]
["JG/SP/KB"]
["2010-02-07"]
[]
[null,"Plant","Capacity","Cost",null,"Ranked","Match","Incremental Capacity","Cumulative capacity"]
[null,1,600,15,null,{"$f":"SMALL($D$6:$D$55,B6)","v":0.4999999},{"$f":"MATCH(F6,$D$6:$D$55,0)","v":15},{"$f":"INDEX($C$6:$C$55,MATCH(F6,$D$6:$D$55,0))","v":200},{"$f":"H6","v":200}]
[null,2,700,18,null,{"$f":"SMALL($D$6:$D$55,B7)","v":0.51},{"$f":"MATCH(F7,$D$6:$D$55,0)","v":16},{"$f":"INDEX($C$6:$C$55,MATCH(F7,$D$6:$D$55,0))","v":300},{"$f":"I6+H7","v":500}]
[null,3,750,20,null,0.7,17,400,{"$f":"I7+H8","v":900}]
[null,4,800,25,null,1,20,350,1250]
[null,5,1000,28,null,2,18,500,1750]
[null,6,800,45.125485714285709,null,2.1,{"$f":"MATCH(F11,$D$6:$D$55,0)","v":19},450,2200]
[null,7,600,46.535657142857147,null,7,46,1200,3400]
[null,8,500,42.305142857142854,null,7.5,47,1500,4900]
[null,9,650,43.715314285714285,null,9,48,1100,6000]
[null,10,700,49.4,null,9.5,49,1400,7400]
[null,11,600,40.894971428571431,null,11,50,1500,8900]
[null,12,650,52.176342857142856,null,15,1,600,9500]
[null,13,400,52.881428571428565,null,18,2,700,10200]
[null,14,500,53.586514285714287,null,20,3,750,10950]
[null,15,200,0.4999999,null,25,4,800,11750]
[null,16,300,0.51,null,28,{"$f":"MATCH(F21,$D$6:$D$55,0)","v":5},1000,12750]
[null,17,400,0.7,null,40.894971428571431,11,600,13350]
[null,18,500,2,null,42.305142857142854,8,500,13850]
[null,19,450,2.1,null,43.715314285714285,9,650,14500]
[null,20,350,1,null,45.125485714285709,6,800,15300]
[null,21,700,66.0822,null,46.065600000000003,26,250,15550]
[null,22,350,67.179000000000002,null,46.535657142857147,7,600,16150]
[null,23,600,65.808000000000007,null,48.259200000000007,42,250,16400]
[null,24,100,76.775999999999996,null,49.4,10,700,17100]
[null,25,250,67.727400000000003,null,49.5,35,250,17350]
[null,26,250,46.065600000000003,null,52.176342857142856,12,650,18000]
[null,27,100,69.646799999999999,null,52.6464,38,250,18250]
[null,28,300,59.227199999999996,null,52.881428571428565,13,400,18650]
[null,29,225,60.323999999999998,null,53.586514285714287,14,500,19150]
[null,30,700,64.711199999999991,null,53.743200000000002,45,250,19400]
[null,31,150,68.275800000000004,null,57.0336,33,250,19650]
[null,32,650,66.356400000000008,null,59.227199999999996,28,300,19950]
[null,33,250,57.0336,null,60.323999999999998,29,225,20175]
[null,34,300,67.453199999999995,null,64.711199999999991,30,700,20875]
[null,35,250,49.5,null,65.808000000000007,23,600,21475]
[null,36,125,69.098399999999998,null,66.0822,21,700,22175]
[null,37,200,68.55,null,66.356400000000008,32,650,22825]
[null,38,250,52.6464,null,66.630600000000001,44,450,23275]
[null,39,200,68.00160000000001,null,66.904799999999994,43,400,23675]
[null,40,250,68.824200000000005,null,67.179000000000002,22,350,24025]
[null,41,100,72.388800000000003,null,67.453199999999995,34,300,24325]
[null,42,250,48.259200000000007,null,67.727400000000003,25,250,24575]
[null,43,400,66.904799999999994,null,68.00160000000001,39,200,24775]
[null,44,450,66.630600000000001,null,68.275800000000004,31,150,24925]
[null,45,250,53.743200000000002,null,68.55,37,200,25125]
[null,46,1200,7,null,68.824200000000005,40,250,25375]
[null,47,1500,7.5,null,69.098399999999998,36,125,25500]
[null,48,1100,9,null,69.646799999999999,27,100,25600]
[null,49,1400,9.5,null,72.388800000000003,41,100,25700]
[null,50,1500,11,null,76.775999999999996,24,100,25800]

{"sheet":"4.10","index":7,"n_rows":25,"n_cols":4,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
["Apple Computer"]
[]
["Date","Return","Return + 1","Cumulative Return"]
[20041201,1.1037E-2,{"$f":"B4+1","v":1.011037},{"$f":"PRODUCT($C$4:$C4)-1","v":1.1036999999999964E-2}]
[20041202,-3.8059000000000003E-2,{"$f":"B5+1","v":0.96194100000000005},{"$f":"PRODUCT($C$4:$C5)-1","v":-2.7442057182999968E-2}]
[20041203,-3.8797999999999999E-2,0.961202,{"$f":"PRODUCT($C$4:$C6)-1","v":-6.5175360248413972E-2}]
[20041206,4.9458000000000002E-2,1.049458,{"$f":"PRODUCT($C$4:$C7)-1","v":-1.8940803215580004E-2}]
[20041207,-4.3934000000000001E-2,0.95606599999999997,{"$f":"PRODUCT($C$4:$C8)-1","v":-6.2042657967106729E-2}]
[20041208,6.2009999999999999E-3,1.0062009999999999,{"$f":"PRODUCT($C$4:$C9)-1","v":-5.6226384489160841E-2}]
[20041209,1.1220000000000001E-2,1.01122,{"$f":"PRODUCT($C$4:$C10)-1","v":-4.5637244523129228E-2}]
[20041210,1.8127999999999998E-2,1.0181279999999999,{"$f":"PRODUCT($C$4:$C11)-1","v":-2.8336556491844633E-2}]
[20041213,-3.6840000000000002E-3,0.99631599999999998,{"$f":"PRODUCT($C$4:$C12)-1","v":-3.1916164617728726E-2}]
[20041214,5.8539999999999998E-3,1.005854,{"$f":"PRODUCT($C$4:$C13)-1","v":-2.624900184540091E-2}]
[20041215,-4.5899999999999999E-4,0.99954100000000001,{"$f":"PRODUCT($C$4:$C14)-1","v":-2.6695953553553808E-2}]
[20041216,2.0472000000000001E-2,1.020472,{"$f":"PRODUCT($C$4:$C15)-1","v":-6.7704731147021358E-3}]
[20041217,-2.4115999999999999E-2,0.97588399999999997,{"$f":"PRODUCT($C$4:$C16)-1","v":-3.0723196385068041E-2}]
[20041220,-3.4928000000000001E-2,0.96507200000000004,{"$f":"PRODUCT($C$4:$C17)-1","v":-6.4578096581730304E-2}]
[20041221,1.5466000000000001E-2,1.015466,{"$f":"PRODUCT($C$4:$C18)-1","v":-5.0110861423463327E-2}]
[20041222,9.4200000000000002E-4,1.000942,{"$f":"PRODUCT($C$4:$C19)-1","v":-4.9216065854924218E-2}]
[20041223,4.078E-3,1.004078,{"$f":"PRODUCT($C$4:$C20)-1","v":-4.5338768971480592E-2}]
[20041227,-1.3278999999999999E-2,0.98672099999999996,{"$f":"PRODUCT($C$4:$C21)-1","v":-5.8015715458308303E-2}]
[20041228,1.6149E-2,1.016149,{"$f":"PRODUCT($C$4:$C22)-1","v":-4.2803611247244522E-2}]
[20041229,4.0509999999999999E-3,1.004051,{"$f":"PRODUCT($C$4:$C23)-1","v":-3.8926008676407053E-2}]
[20041230,5.587E-3,1.005587,{"$f":"PRODUCT($C$4:$C24)-1","v":-3.355648828688218E-2}]
[20041231,-6.1729999999999997E-3,0.99382700000000002,{"$f":"PRODUCT($C$4:$C25)-1","v":-3.9522344084687244E-2}]

{"sheet":"4.13","index":8,"n_rows":25,"n_cols":2,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
["Apple Computer"]
[]
["Date","Return"]
[20041201,1.1037E-2]
[20041202,-3.8059000000000003E-2]
[20041203,-3.8797999999999999E-2]
[20041206,4.9458000000000002E-2]
[20041207,-4.3934000000000001E-2]
[20041208,6.2009999999999999E-3]
[20041209,1.1220000000000001E-2]
[20041210,1.8127999999999998E-2]
[20041213,-3.6840000000000002E-3]
[20041214,5.8539999999999998E-3]
[20041215,-4.5899999999999999E-4]
[20041216,2.0472000000000001E-2]
[20041217,-2.4115999999999999E-2]
[20041220,-3.4928000000000001E-2]
[20041221,1.5466000000000001E-2]
[20041222,9.4200000000000002E-4]
[20041223,4.078E-3]
[20041227,-1.3278999999999999E-2]
[20041228,1.6149E-2]
[20041229,4.0509999999999999E-3]
[20041230,5.587E-3]
[20041231,-6.1729999999999997E-3]

{"sheet":"4.14","index":9,"n_rows":25,"n_cols":2,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
["Apple Computer"]
[]
["Date","Return"]
[20041201,1.1037E-2]
[20041202,-3.8059000000000003E-2]
[20041203,-3.8797999999999999E-2]
[20041206,4.9458000000000002E-2]
[20041207,-4.3934000000000001E-2]
[20041208,6.2009999999999999E-3]
[20041209,1.1220000000000001E-2]
[20041210,1.8127999999999998E-2]
[20041213,-3.6840000000000002E-3]
[20041214,5.8539999999999998E-3]
[20041215,-4.5899999999999999E-4]
[20041216,2.0472000000000001E-2]
[20041217,-2.4115999999999999E-2]
[20041220,-3.4928000000000001E-2]
[20041221,1.5466000000000001E-2]
[20041222,9.4200000000000002E-4]
[20041223,4.078E-3]
[20041227,-1.3278999999999999E-2]
[20041228,1.6149E-2]
[20041229,4.0509999999999999E-3]
[20041230,5.587E-3]
[20041231,-6.1729999999999997E-3]

{"sheet":"4.15","index":10,"n_rows":25,"n_cols":3,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
["Apple Computer"]
[]
["Date","Return"]
[20041201,1.1037E-2,{"$f":"CumulativeReturn($B$4:$B4)","v":1.1036999999999964E-2}]
[20041202,-3.8059000000000003E-2,{"$f":"CumulativeReturn($B$4:$B5)","v":-2.7442057182999968E-2}]
[20041203,-3.8797999999999999E-2,{"$f":"CumulativeReturn($B$4:$B6)","v":-6.5175360248413972E-2}]
[20041206,4.9458000000000002E-2,{"$f":"CumulativeReturn($B$4:$B7)","v":-1.8940803215580004E-2}]
[20041207,-4.3934000000000001E-2,{"$f":"CumulativeReturn($B$4:$B8)","v":-6.2042657967106729E-2}]
[20041208,6.2009999999999999E-3,{"$f":"CumulativeReturn($B$4:$B9)","v":-5.6226384489160841E-2}]
[20041209,1.1220000000000001E-2,{"$f":"CumulativeReturn($B$4:$B10)","v":-4.5637244523129228E-2}]
[20041210,1.8127999999999998E-2,{"$f":"CumulativeReturn($B$4:$B11)","v":-2.8336556491844633E-2}]
[20041213,-3.6840000000000002E-3,{"$f":"CumulativeReturn($B$4:$B12)","v":-3.1916164617728726E-2}]
[20041214,5.8539999999999998E-3,{"$f":"CumulativeReturn($B$4:$B13)","v":-2.624900184540091E-2}]
[20041215,-4.5899999999999999E-4,{"$f":"CumulativeReturn($B$4:$B14)","v":-2.6695953553553808E-2}]
[20041216,2.0472000000000001E-2,{"$f":"CumulativeReturn($B$4:$B15)","v":-6.7704731147021358E-3}]
[20041217,-2.4115999999999999E-2,{"$f":"CumulativeReturn($B$4:$B16)","v":-3.0723196385068041E-2}]
[20041220,-3.4928000000000001E-2,{"$f":"CumulativeReturn($B$4:$B17)","v":-6.4578096581730304E-2}]
[20041221,1.5466000000000001E-2,{"$f":"CumulativeReturn($B$4:$B18)","v":-5.0110861423463327E-2}]
[20041222,9.4200000000000002E-4,{"$f":"CumulativeReturn($B$4:$B19)","v":-4.9216065854924218E-2}]
[20041223,4.078E-3,{"$f":"CumulativeReturn($B$4:$B20)","v":-4.5338768971480592E-2}]
[20041227,-1.3278999999999999E-2,{"$f":"CumulativeReturn($B$4:$B21)","v":-5.8015715458308303E-2}]
[20041228,1.6149E-2,{"$f":"CumulativeReturn($B$4:$B22)","v":-4.2803611247244522E-2}]
[20041229,4.0509999999999999E-3,{"$f":"CumulativeReturn($B$4:$B23)","v":-3.8926008676407053E-2}]
[20041230,5.587E-3,{"$f":"CumulativeReturn($B$4:$B24)","v":-3.355648828688218E-2}]
[20041231,-6.1729999999999997E-3,{"$f":"CumulativeReturn($B$4:$B25)","v":-3.9522344084687244E-2}]